package com.heeexy.example.entity;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.FillPatternTypeEnum;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import org.apache.ibatis.type.Alias;
import org.springframework.stereotype.Repository;

import java.io.Serializable;
import java.util.Date;

@Data
@EqualsAndHashCode
@Repository
@HeadStyle(fillPatternType = FillPatternTypeEnum.SOLID_FOREGROUND, fillForegroundColor = 99)
@ContentFontStyle(fontHeightInPoints=12,bold= BooleanEnum.FALSE,fontName = "宋体")
@HeadFontStyle(fontHeightInPoints = 12,bold= BooleanEnum.FALSE,fontName = "宋体")
@ContentRowHeight(15)
@HeadRowHeight(15)
public class StudentInfo{

        @ExcelIgnore
        private Integer s_id;

        @ColumnWidth(20)
        @ExcelProperty(value = {"学号"})
        //@ExcelProperty(index = 0)
        private String s_number;

        @ColumnWidth(20)
        @ExcelProperty(value = {"学生姓名"})
        //@ExcelProperty(index = 1)
        private String s_name;//

        @ColumnWidth(12)
        @ExcelProperty(value = {"角色"})
        //@ExcelProperty(index = 2)
        private String s_role;

        @ColumnWidth(12)
        @ExcelProperty(value = {"性别"})
        //@ExcelProperty(index = 3)
        private String s_sex;

        @ColumnWidth(20)
        @ExcelProperty(value = {"手机号码"})
       //@ExcelProperty(index = 4)
        private String s_telephone;

        @ColumnWidth(20)
        @ExcelProperty(value = {"邮箱"})
        //@ExcelProperty(index = 5)
        private String s_email;

        @ColumnWidth(12)
        @ExcelProperty(value = {"院系"})
        //@ExcelProperty(index = 6)
        private String s_faculties;

        @ColumnWidth(12)
        @ExcelProperty(value = {"专业"})
        //@ExcelProperty(index = 7)
        private String s_specialized;

        @ColumnWidth(12)
        @ExcelProperty(value = {"班级"})
        //@ExcelProperty(index = 8)
        private String s_classid;

        @ColumnWidth(20)
        @ExcelProperty(value = {"入学时间"})
        //@ExcelProperty(index = 9)
        private String s_schoolYeal;

        @ColumnWidth(20)
        @ExcelProperty(value = {"身份证号"})
        //@ExcelProperty(index = 10)
        private String s_Idcard;

        @ColumnWidth(20)
        @ExcelProperty(value = {"机构代码"})
        //@ExcelProperty(index = 11)
        private String s_fid;

        @ColumnWidth(20)
        @ExcelProperty(value = {"登入密码"})
        //@ExcelProperty(index = 12)
        private String s_password;

        @ColumnWidth(20)
        @ExcelIgnore
        private Integer s_schoolid;

        @ExcelIgnore
        private Date s_createtime;

//        @ExcelProperty("账户Id")
//        @ColumnWidth(20)
        @ExcelIgnore
        private Integer u_id;

}
